UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p0X4fJT7RvcykKD/kH1Y+8XsOWifPZV2I5YUzkNA4+g='
WHERE
key_id = 'a105f87edcfcebf1e631855e56a97dcad9bd8ea6b9c32ea653a37abb358df9b7'
AND (
token = 'p0X4fJT7RvcykKD/kH1Y+8XsOWifPZV2I5YUzkNA4+g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)