UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gYcc/PRZzGci54TzygV6i7RUfwrj0B5BjvX3quS0qTk='
WHERE
key_id = 'c309138e9376b928405406f705869ffec3bfbdd27110536b06c10ae3f97e55f2'
AND (
token = 'gYcc/PRZzGci54TzygV6i7RUfwrj0B5BjvX3quS0qTk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)