UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B2LpY9BPHSX7fYfX4nmNojzgT4pyfyLNVCfIJQR61/k='
WHERE
key_id = 'a9f9abc34843a4509ecda02fdd05856e6cace2a34f07bd07b0b98e741212a134'
AND (
token = 'B2LpY9BPHSX7fYfX4nmNojzgT4pyfyLNVCfIJQR61/k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)