UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UgvzL/az+pLpERsqVBC06J6W8Zn0X9/j/vS80ZDPkoU='
WHERE
key_id = '8fb15fcd47a1e45eaa5c37fbd6ce1ccdf965f0374e07397915ff0ac6788fe9b3'
AND (
token = 'UgvzL/az+pLpERsqVBC06J6W8Zn0X9/j/vS80ZDPkoU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)