UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/9oMGBqBrDdLvnwD8jKvtpZiwrJ0rEocDI7A/ytwabA='
WHERE
key_id = 'f6c7e18696e1ead3c45046d2cff95b6253762d1456fc0fbc8c99f34107aa14f1'
AND (
token = '/9oMGBqBrDdLvnwD8jKvtpZiwrJ0rEocDI7A/ytwabA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)