UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XNVce1RbvQs/kpR1kbbFCTdiO9OhRa2cWxoz3oQxpAg='
WHERE
key_id = '166dce58b3a26d8ca76845ac7cdaa986076ebc12e915faee66bdb30f7baabbb9'
AND (
token = 'XNVce1RbvQs/kpR1kbbFCTdiO9OhRa2cWxoz3oQxpAg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)