UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8ok0+uRNw6QiJ7r6+ZB/hizq5ynM6qgwdlJKLU9Ocgc='
WHERE
key_id = '938e376039f107b7e7da0e22ae074f1fc717062250a217658a5188778cd31d68'
AND (
token = '8ok0+uRNw6QiJ7r6+ZB/hizq5ynM6qgwdlJKLU9Ocgc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)