UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8i5gupB/lns8aF8XzcAlZLy6/5vd4O6Ht4U7SK+TFPg='
WHERE
key_id = 'debd72e387c82d5ab7323b1e75962f4efffb3d36013c3dced058ca15276e0616'
AND (
token = '8i5gupB/lns8aF8XzcAlZLy6/5vd4O6Ht4U7SK+TFPg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)