UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mcnTlEJU95c6oG+t2v+9A0i69FKpbO94VVSkv268RWs='
WHERE
key_id = 'cdbad601d74cfd730f3c507de02d0824ebaf0dfffdae865fbea32acdb4a7356b'
AND (
token = 'mcnTlEJU95c6oG+t2v+9A0i69FKpbO94VVSkv268RWs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)