UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WfWTrtzX1+4lBFg134U2zLNnn05Q15VX40vykXwngPE='
WHERE
key_id = 'a46a7a36d0cead30c34d09bb65d812a418524ea9d5bddecf4e3ad672925270af'
AND (
token = 'WfWTrtzX1+4lBFg134U2zLNnn05Q15VX40vykXwngPE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)