UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vD2zl0oSVIC67IFPl5QRB1V0j4uPlLXlth37m2ehC2Q='
WHERE
key_id = '8590937c60e592be5b9404b8bd8be4b6e29f4cdee289b56a196d5b0bac1a74a1'
AND (
token = 'vD2zl0oSVIC67IFPl5QRB1V0j4uPlLXlth37m2ehC2Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)