UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7QERnSkKafzl5u8jqhypeIAqZNply1gbgpVDLEuWT9o='
WHERE
key_id = 'be442dc8b1b4e5dcffc749aeb83771cfa22c9fcd58e8864bd4093231bb80d6b0'
AND (
token = '7QERnSkKafzl5u8jqhypeIAqZNply1gbgpVDLEuWT9o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)