UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pnr4nrObM1YQc2eIjf/u6w7YltPuONOufO9EhGFt9Rg='
WHERE
key_id = '465b702b8485594961ce9a5b6c460ed37506b0718cfd8f398e2d60a32c637d25'
AND (
token = 'pnr4nrObM1YQc2eIjf/u6w7YltPuONOufO9EhGFt9Rg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)