UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9eUhEtUqI57ePULCky1LSzWRpTVGRezGpYt0UuI64w8='
WHERE
key_id = '49531a7e689125f92a4ef9eab7a80b350f8c7aa42ac6d0a6aa15cad5db347fb5'
AND (
token = '9eUhEtUqI57ePULCky1LSzWRpTVGRezGpYt0UuI64w8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)