UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MgiZKdeNsTPBC13kvXkBqUsQinXN9IeNS4M2dJTI+r0='
WHERE
key_id = 'cf604b8a4d367ef3d97b5a7956ff94f0941258dbb2a13310ba1037dbe551aa39'
AND (
token = 'MgiZKdeNsTPBC13kvXkBqUsQinXN9IeNS4M2dJTI+r0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)