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