UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cW5LQri2+nTi9FlvH8Dq38I5DB2G1+414ums9CcL+AM='
WHERE
key_id = 'a670cf4d685e92b98e07e664908a6b6228fad0f9e3e180f680be7890cbcdaedf'
AND (
token = 'cW5LQri2+nTi9FlvH8Dq38I5DB2G1+414ums9CcL+AM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)