UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qpthDO2Re1lJH4qE+rWXzeLU9ECUbq09c+agtEw5ITk='
WHERE
key_id = 'f16ee750bc6c7a55c9f8a070aea5c7705ddc4ff64ab0738d401aea8d20a709de'
AND (
token = 'qpthDO2Re1lJH4qE+rWXzeLU9ECUbq09c+agtEw5ITk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)