UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6P2OZfUicFhlXxvCS5EPKodWNi3EhcUzlF4ll9wAQtc='
WHERE
key_id = 'bddad7bc1c2cb3046a17c4891ec4a6d3823c2eca7194974eda73ef3a66f50b40'
AND (
token = '6P2OZfUicFhlXxvCS5EPKodWNi3EhcUzlF4ll9wAQtc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)