UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2vYZs7IY9hb9tRal45S0TV2MwY6UxPS6ofHLE2/XY3o='
WHERE
key_id = '6cdede662443c00244bc5869ec3af3c7ee2f20e48ee7788aa940341835f8a599'
AND (
token = '2vYZs7IY9hb9tRal45S0TV2MwY6UxPS6ofHLE2/XY3o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)