UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hRGpk7lUqo6o/OMpsxUHZ22eDm1jZs6EjN9p6slddsE='
WHERE
key_id = '1865f152838f9188fcb9153c758e6ce8678d08c48698362235ae66848d0edadf'
AND (
token = 'hRGpk7lUqo6o/OMpsxUHZ22eDm1jZs6EjN9p6slddsE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)