UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J+/SCix+A91nd/XXjsQeGwDB+czhaDMSghszEyUlPt4='
WHERE
key_id = 'c4ef8638e01ce78e1b398362e0f416739a5600e33b99f6ab1cb41aae5bcb313e'
AND (
token = 'J+/SCix+A91nd/XXjsQeGwDB+czhaDMSghszEyUlPt4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)