UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Nuw77YelE59+YBn+Q/3B3YbmRxqa8A0m0ATifsclb2Y='
WHERE
key_id = 'a97dd9986044c5877f8a6fba3501511e4db73a8e42be6593fd00309c9fa5268a'
AND (
token = 'Nuw77YelE59+YBn+Q/3B3YbmRxqa8A0m0ATifsclb2Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)