UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6xHmwhnc0E4SjmSftodE8wVnS4GsXxTZJ9MV+OxqMe0='
WHERE
key_id = '0d1df8966ae0d768b8a72a4a535f6bef62e0b974be30b16ac8ef2a29f7f5054a'
AND (
token = '6xHmwhnc0E4SjmSftodE8wVnS4GsXxTZJ9MV+OxqMe0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)