UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3ZhG7zz0g/UWbs/UPT63e0y0qwiJarghpUt26sLt71Y='
WHERE
key_id = '29ea76f372605839a1274adb1be86800122698a59a438dc305c736a9c59ca81a'
AND (
token = '3ZhG7zz0g/UWbs/UPT63e0y0qwiJarghpUt26sLt71Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)