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