UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qiSc5whEtY6Tv2zk2DvRDNQmehLw0BSdcfTJNzIYKZE='
WHERE
key_id = 'eaaaf417d4de61a677b5e480dc680c2f0a4f10c8ed372bad7c34de12e65891db'
AND (
token = 'qiSc5whEtY6Tv2zk2DvRDNQmehLw0BSdcfTJNzIYKZE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)