UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZHSr2I2BGJwbgA8eISdYay4+8RKi5iVaEjDDk3gjhVU='
WHERE
key_id = '6952488558c34ff51093403a7630e31a5dc5705301355ca9dd77db344ffbad12'
AND (
token = 'ZHSr2I2BGJwbgA8eISdYay4+8RKi5iVaEjDDk3gjhVU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)