UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JJHjBQoid73lzURZLz7mckhKckg3TE38CmQsi7V4M6I='
WHERE
key_id = '6d005c19996bd73a0fa6f66de0c255e61844fd39e84242f4740e79871fc5487c'
AND (
token = 'JJHjBQoid73lzURZLz7mckhKckg3TE38CmQsi7V4M6I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)