UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VWWzjwM+Y02PibwfQzZbzDbSclV64dT3+5weaqVEc3M='
WHERE
key_id = 'aa0a8b825f4836a6b62059d3e0f1f3d363baae5936f142adadf995aed15e858b'
AND (
token = 'VWWzjwM+Y02PibwfQzZbzDbSclV64dT3+5weaqVEc3M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)