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