UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1ZpRNbvQIKoyf3RfTcuT6Dg39QocTl4pHe48hRa+7/M='
WHERE
key_id = '3454896cd69a248c3e639512c3f678faeff57db5bd107506cc082034d8857bdb'
AND (
token = '1ZpRNbvQIKoyf3RfTcuT6Dg39QocTl4pHe48hRa+7/M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)