UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kpvEf8hx1k3fAhpPRCC2vM+zGfIhkk823c4GeIfKrK0='
WHERE
key_id = 'e8365f55c9224d9ea31c32198589dbbd3c70707b3f545e6433d77757b6651f3d'
AND (
token = 'kpvEf8hx1k3fAhpPRCC2vM+zGfIhkk823c4GeIfKrK0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)