UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L6Z/6f4d2CaXIqUaHzrZvCkXKZaJ57HlL3jZu4A4pnw='
WHERE
key_id = 'b92e63c4c48ec7fd0d3d947cda98603bb1689be9e54d4d7d5ad996201e205af7'
AND (
token = 'L6Z/6f4d2CaXIqUaHzrZvCkXKZaJ57HlL3jZu4A4pnw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)