UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G1QSNxuNes5fikc5hK9M1xEKa0oVWrCCX9E532i6tYs='
WHERE
key_id = 'b6247c696f546312e68c1dd66eb75040a0517926fb1f8855189933203724c389'
AND (
token = 'G1QSNxuNes5fikc5hK9M1xEKa0oVWrCCX9E532i6tYs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)