UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yZRtTlZqS5pQAZFboXAXd03TzNNHuCdsxdHmRee0UfI='
WHERE
key_id = '93bb4da029f1a64b46b20ebb2eb036b62bd0debf7927e87a32954221f4a02f64'
AND (
token = 'yZRtTlZqS5pQAZFboXAXd03TzNNHuCdsxdHmRee0UfI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)