UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N/ahhBfVYtdTNv0PlAbRwyuiByiURBK1fa+lctQPi3I='
WHERE
key_id = 'a34501af2b4244ac36517c94e1c73f152e8208d8aa945f88af04d40a92e0fe8c'
AND (
token = 'N/ahhBfVYtdTNv0PlAbRwyuiByiURBK1fa+lctQPi3I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)