UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tkQR6z1UHs92I2qwJDEkZYInfM3I76mhXZLARM1AoZM='
WHERE
key_id = '9318a67539c49181fa96e86e6e253c4cb2e6ef3301f7e1b505745ce93d4eba2c'
AND (
token = 'tkQR6z1UHs92I2qwJDEkZYInfM3I76mhXZLARM1AoZM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)